package com.qen.xlsx

import cn.hutool.poi.excel.ExcelUtil

fun main() {
    val rows = mutableListOf(
        mutableListOf("aa1","bb1","cc1","dd1"),
        mutableListOf("aa2","bb2","cc2","dd2"),
        mutableListOf("aa3","bb3","cc3","dd3"),
        mutableListOf("aa4","bb4","cc4","dd4"),
        mutableListOf("aa5","bb5","cc5","dd5"),
        mutableListOf("aa6","bb6","cc6","dd6"),
        mutableListOf("aa7","bb7","cc7","dd7"),
    )
    val writer = ExcelUtil.getWriter("/Users/a1/Documents/Git/Kotlin/Eleven/out/writeTest.xlsx")
    writer.passCurrentRow()
    writer.merge(3,"测试标题")
    writer.write(rows,true)
    writer.close()
}